* import_mw.do
* This dofile imports the minimum wage series into Stata format
* Inputs: Data/Original/MW/serie_salario_minimo.xlsx
* Outputs: Data/Importable/MW/serie_salario_minimo.dta

clear all
version 13.1

* Project info

cap project, doinfo
if _rc==198 {
	loc master "C:/Users/jorpp/Dropbox (Brown)/Col_Minimum_Wage"
	loc pr=0
}
else {
	project, doinfo
	local master "`r(pdir)'"
	local doname "`r(dofile)'" 
	project, original ("`master'/Data/Original/MW/serie_salario_minimo.xlsx")
	loc pr=1
}

import excel "`master'/Data/Original/MW/serie_salario_minimo.xlsx", sheet("1.1.1 Serie historica") cellrange(A5:H35) firstrow clear

save "`master'/Data/Importable/MW/serie_salario_minimo.dta" ,replace

if `pr'{ 
	project, creates("`master'/Data/Importable/MW/serie_salario_minimo.dta")
}
